#region Using directives
using System;
using System.Data;

using WP.Commons;
#endregion

namespace WP.MF.DataEntity
{

	/*
	 * Created by Web Smart Create Code Tool
	 * At 4/22/2005
	 */

	//=========MUser  ============================
	[System.ComponentModel.DesignerCategory("Code")]
    public class MUserDEL : DataSet, IDataEntity
	{
		//=========mUser ============================
		public const string TABLENAME_MUSER="mUser";
		public const string RECID="RecId";
		public const string USERNAME="UserName";
		public const string GLSECURGRP="glSecurGrp";
		public const string APSECURGRP="apSecurGrp";
		public const string ARSECURGRP="arSecurGrp";
		public const string OESECURGRP="oeSecurGrp";
		public const string IMSECURGRP="imSecurGrp";
		public const string POSECURGRP="poSecurGrp";
		public const string RMSECURGRP="rmSecurGrp";
		public const string TWSECURGRP="twSecurGrp";
		public const string TPSECURGRP="tpSecurGrp";
		public const string SMSECURGRP="smSecurGrp";
		public const string MFSECURGRP="mfSecurGrp";
		public const string LANGUAGE="Language";
        public const string PASSWORD = "PassWord";
		public const string DESCRIPTION="Description";
		public const string COMPANYNAME="CompanyName";
        public const string AbleToExcel = "AbleToExcel";
        public const string AbleToChangeBOMFormula = "AbleToChangeBOMFormula";
        public const string AbleToChangeFormula = "AbleToChangeFormula";
        public const string TITLE = "Title";
        public const string Phone = "Phone";
        public const string InitialName = "InitialName";
        public const string approval1 = "approval1";
        public const string approval2 = "approval2";
        public const string approval3 = "approval3";
        public const string approval4 = "approval4";
        public const string approval5 = "approval5";

        public const string AbleToPostWorkQty="AbleToPostWorkQty";
	    public const string AbleToPostSTDSalary="AbleToPostSTDSalary";
	    public const string AbleToOtherSalary="AbleToOtherSalary";

        public const string RECSTAMP = "RecStamp";
        private System.Collections.Specialized.NameValueCollection mVarCollection = new System.Collections.Specialized.NameValueCollection();
        public System.Collections.Specialized.NameValueCollection VarCollection
        {
            get { return mVarCollection; }
            set { mVarCollection = value; }
        }

		public MUserDEL()
		{
			//Create mUser structure
			CreatemUserStructure();

		}

		//=========mUser============================
		private void CreatemUserStructure()
		{
			DataTable table;
			DataColumnCollection DCC;
			DataColumn DC=new DataColumn();
			table=new DataTable (TABLENAME_MUSER);
			DCC=table.Columns;

			DC=new DataColumn(RECID,typeof(System.Int32));
			DCC.Add(DC);

			DC=new DataColumn(USERNAME,typeof(System.String));
			DCC.Add(DC);

            DC = new DataColumn(TITLE, typeof(System.String));
            DCC.Add(DC);

			DC=new DataColumn(GLSECURGRP,typeof(System.Int32));
			
			DCC.Add(DC);

			DC=new DataColumn(APSECURGRP,typeof(System.Int32));
			
			DCC.Add(DC);

			DC=new DataColumn(ARSECURGRP,typeof(System.Int32));
			
			DCC.Add(DC);

			DC=new DataColumn(OESECURGRP,typeof(System.Int32));
			
			DCC.Add(DC);

			DC=new DataColumn(IMSECURGRP,typeof(System.Int32));
			
			DCC.Add(DC);

			DC=new DataColumn(POSECURGRP,typeof(System.Int32));
			
			DCC.Add(DC);

			DC=new DataColumn(RMSECURGRP,typeof(System.Int32));
			
			DCC.Add(DC);

			DC=new DataColumn(TWSECURGRP,typeof(System.Int32));
			
			DCC.Add(DC);

			DC=new DataColumn(TPSECURGRP,typeof(System.Int32));
			
			DCC.Add(DC);

			DC=new DataColumn(SMSECURGRP,typeof(System.Int32));
			
			DCC.Add(DC);

			DC=new DataColumn(MFSECURGRP,typeof(System.Int32));
			
			DCC.Add(DC);

			DC=new DataColumn(LANGUAGE,typeof(System.String));
			DC.DefaultValue="E";
			DCC.Add(DC);

			DC=new DataColumn(DESCRIPTION,typeof(System.String));
			DCC.Add(DC);			

            DC = new DataColumn(Phone , typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(InitialName, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(InitialName);

            DC = new DataColumn(RECSTAMP, typeof(System.Byte[]));
            DCC.Add(DC);

            DC = new DataColumn(AbleToExcel, typeof(System.Boolean));
            DC.DefaultValue = false;
            DCC.Add(DC);


            DC = new DataColumn(AbleToChangeBOMFormula, typeof(System.Boolean));
            DC.DefaultValue = false;
            DCC.Add(DC);

            DC = new DataColumn(AbleToChangeFormula, typeof(System.Boolean));
            DC.DefaultValue = false;
            DCC.Add(DC);

            DC = new DataColumn(approval1, typeof(System.Boolean));
            DC.DefaultValue = false;
            DCC.Add(DC);
            DC = new DataColumn(approval2, typeof(System.Boolean));
            DC.DefaultValue = false;
            DCC.Add(DC);
            DC = new DataColumn(approval3, typeof(System.Boolean));
            DC.DefaultValue = false;
            DCC.Add(DC);
            DC = new DataColumn(approval4, typeof(System.Boolean));
            DC.DefaultValue = false;
            DCC.Add(DC);
            DC = new DataColumn(approval5, typeof(System.Boolean));
            DC.DefaultValue = false;
            DCC.Add(DC);

            DC = new DataColumn(AbleToOtherSalary, typeof(System.Boolean));
            DC.DefaultValue = false;
            DCC.Add(DC);

            DC = new DataColumn(AbleToPostSTDSalary , typeof(System.Boolean));
            DC.DefaultValue = false;
            DCC.Add(DC);

            DC = new DataColumn(AbleToPostWorkQty, typeof(System.Boolean));
            DC.DefaultValue = false;
            DCC.Add(DC);

			this.Tables.Add (table);
		}

	}
}